package cn.ljy.uem.dao;

import cn.ljy.authority.dao.BaseMapper;
import cn.ljy.uem.model.SchoolCourseSectionResource;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * 学校课程章节资源dao层
 *
 * @author 小锋
 * @date 2022/08/24
 */
@Mapper
public interface SchoolCourseSectionResourceMapper extends BaseMapper<SchoolCourseSectionResource> {



    //通过章节id查询资源
    @Select("SELECT * FROM school_course_section_resource WHERE section_id=#{SectionId}")
    List<SchoolCourseSectionResource> getResourceBySectionId(String SectionId);

    /**
     * 王秋林 通过章节Id删除课程资源表的记录
     * @param sectionIds 章节Id
     */
    int deleteBySectionIds(java.io.Serializable[] sectionIds);

    int deleteByResourceIds(java.io.Serializable[] resourceIds);
}
